SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393516 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393516 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561163,645922,352780,38567,924540,997390,745627,775770,786119,866580,689650,91275,989849,414943,229933,963277,609614,830674,314315,697426,538923,507454,64432,784883,365646,907104,637818,200600,292256,218344,50016,882580,674052,340670,982889,338489,664650,1014838,5943,1039232,418903,558850,105871,936014,926787,852036,128366,318291,589221,719701,283050,95256,10238,1017800,437741,433201,256278,38016,249183,602178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000877s ]