SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331836 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331836 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716097,525267,679826,936588,432593,1008510,156721,224646,1020074,436521,941891,705729,778261,95140,795021,137090,322808,445494,233171,910503,342318,335484,526113,999366,202140,497810,165272,701018,419135,540466,302341,117934,369704,220680,192298,833027,823556,872019,301648,222485,660337,616305,419142,658873,867734,116714,303698,970514,135241,533912,54201,194072,201115,764771,716840,865480,641153,210239,482978,457583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000363s ]