SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313713 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313713 [ RunTime:0.003961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715511,331060,125427,910350,605369,385635,958734,870617,590582,487786,427941,743962,513853,383533,799714,488014,512705,187631,357404,440055,663844,500907,407629,525330,160742,542867,361742,739229,514081,911549,636008,387003,534082,796159,402828,651966,980254,942375,28374,839323,513384,578721,570784,365007,814498,299014,761434,227551,809530,618996,254606,578250,807763,35362,1029262,793017,829698,641171,63406,339561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002238s ]