SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407212 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407212 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414391,36045,41927,1039228,1015960,586140,166716,742483,337977,907316,844609,489272,477194,472664,582220,642037,719886,463014,781865,1036698,82329,588569,634096,521533,525559,512773,16708,497292,59427,376957,575509,56204,716332,249877,1002380,557388,560060,49118,999060,345591,290121,987316,558059,149824,797248,925269,266789,113905,759880,602467,573325,584567,829725,1034975,984857,32218,145465,644390,497592,623014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]