SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198405 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198405 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988080,288806,807816,911876,526233,478533,108680,948048,710938,734875,51828,470737,110830,468997,401006,331587,292962,417854,408686,200412,241737,77604,695401,731533,1037275,880571,890529,788831,618826,343570,279892,709746,597952,404304,494440,767939,393584,112954,568823,703420,958074,798366,421598,112649,380489,523405,1027325,240541,675582,527986,24756,644679,951135,548299,981780,905530,420103,79212,81055,382540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]