SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497810 LIMIT 1 [ RunTime:0.000711s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497810 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260413,1035594,484942,832392,142761,416629,451786,672335,454918,42927,264845,347702,951682,904379,474669,446420,450977,558401,793516,691569,356170,373661,887027,797231,948293,120337,981753,71717,661204,773960,632649,450339,901385,967687,940068,606114,401315,269126,129689,154539,154523,511668,572972,147981,993794,564057,480832,457718,186952,948996,611258,242969,1028256,600831,1041773,413791,166724,909983,291637,258664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000885s ]