SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322928 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322928 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876958,940953,1000229,320859,953058,828825,694992,927290,150950,804211,1003012,29923,1047221,1013155,791628,355202,996798,833226,791095,878580,241576,663462,139997,857878,280492,519020,756357,232834,458826,61133,377254,848621,115733,321028,872340,675959,545280,38136,664393,222359,712681,461365,673745,147356,311015,494601,826479,637891,836318,743437,317469,722439,519679,993990,679532,281056,65410,470169,588959,1039632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]