SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310341 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310341 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841592,686006,826205,435301,95545,500703,109934,973069,733857,395902,904854,59066,282908,562532,898762,197386,560640,175064,372169,477526,750009,438470,509929,940798,339252,203787,8220,99671,642023,854867,30605,949748,991971,88302,755928,268264,558360,305974,741884,104776,1034981,151714,847438,169870,778990,999131,541958,17770,225133,246974,730204,790870,485075,539212,1035789,379921,428895,609577,271528,793538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]