SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554324 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554324 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935468,1024321,174750,816666,344771,607864,535888,623911,591354,981101,1033109,961142,787540,379388,123064,661133,462315,102869,171369,900291,806809,679385,554754,199899,957473,54152,494060,851351,555639,150597,872197,940844,849854,279771,147570,722457,914537,852731,662867,1017414,228657,61878,500094,846517,116333,951321,992502,457720,226110,1008425,871509,448455,1021137,830853,243296,125904,935415,676059,762333,776801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002868s ]