SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038660 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038660 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700652,698670,264820,425806,776693,909349,212586,463671,195784,256987,373760,487219,321428,377284,643171,536375,874531,427755,330920,972692,131062,557123,31880,507961,1028102,55505,973652,448644,507415,655187,584474,549669,234558,734707,434851,21848,184007,327375,91981,68522,176511,154120,490217,152490,658294,763538,463354,520955,222485,111545,310059,850467,799000,763644,107084,292684,207514,1042639,814426,302560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]