SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341171 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341171 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720381,224998,276162,630730,531004,344467,252622,213541,737485,177404,981533,20813,784591,771984,534047,580022,212470,618317,689665,934381,1038774,420181,560954,1035580,132635,43164,414541,214213,164839,1047020,324854,435006,762699,149070,303570,1009620,335060,418902,772984,249520,1037039,671244,529049,713265,343249,1015796,845369,543819,257189,211594,305664,598587,121360,365410,340816,557321,578302,373285,17619,398306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]