SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801260 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801260 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5778,270836,300067,822327,82348,923818,541382,571288,173113,360159,647362,34596,107457,200834,845776,909032,869038,538063,889268,671970,810149,166526,787509,967100,363151,426120,591978,223500,64996,203249,467862,733616,925035,643514,893955,889899,979539,108728,808933,844071,516884,969421,857443,428617,603930,423033,776418,44086,871892,465042,161764,375613,897091,232590,574658,941174,750201,728281,282330,905641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]