SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111491 LIMIT 1 [ RunTime:0.000928s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111491 [ RunTime:0.003125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159998,551482,368957,5332,836667,389016,603791,810858,283798,957790,285637,329723,392621,603643,39901,424012,792777,208311,830873,113816,940938,504298,753419,903328,991566,1004972,532092,698320,981167,174593,613003,387501,833854,595483,1020397,580090,631539,326497,801914,1014546,356081,152937,784049,856421,86518,68017,757612,775854,839198,997585,379933,987671,439999,847735,966491,426956,993299,286815,108610,120025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]