SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345209 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345209 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750226,370649,902743,414885,505015,759738,417659,578304,216082,747214,50515,558545,95894,556959,978253,1029896,986276,304216,331883,735139,26505,539494,812020,530369,819109,290102,1024298,397467,407307,366899,868787,451294,544725,722285,1021824,137890,577047,247870,778622,1000601,127645,819816,117600,926293,905270,682921,310864,204173,990038,511290,174241,461579,238005,471863,45298,778797,182440,10339,745344,6463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]