SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508081 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508081 [ RunTime:0.004123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942394,1029652,355148,237854,380489,967595,919918,715542,767512,445447,376246,868045,862970,208225,790395,1039498,435242,519611,1006076,619239,104801,112726,804262,649526,381802,718172,19749,504726,396470,199951,634260,384052,595432,132870,814635,240478,108197,985152,725680,1008703,69970,394768,689162,753018,1034241,1038902,1015241,53418,966585,933299,21406,874453,949112,220709,610164,153476,541639,812275,565425,716736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]