SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549396 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549396 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991437,15297,1026215,654671,71788,190925,467849,1046202,1019244,181711,283988,696475,662005,79348,787846,894303,690129,1026669,738840,331835,475717,977810,112270,189374,1043681,87894,660887,536359,767949,758280,466733,951202,429415,175480,1009693,135745,367893,254587,22635,399364,985438,899282,725210,572609,91274,698473,762118,767208,836347,502962,868963,918394,191509,530765,350984,401897,189885,157191,279544,11035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]