SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861404 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861404 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200593,822474,165416,653971,132984,823337,515360,343437,759695,898005,565377,224433,642972,743641,638939,81976,330451,957509,902051,689914,241743,160994,920012,435106,323896,221984,605554,206354,921890,533220,99475,7906,696915,920232,109910,898713,581611,135667,230214,282621,967324,247800,149405,495219,324186,752942,975446,194822,859043,160113,997161,172920,97986,116603,57755,585404,214580,729488,360131,820758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]