SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55180 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55180 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897449,398591,948547,6212,142993,749260,249421,20075,97282,966886,726343,564745,58208,547546,609635,709059,465543,684956,884167,658253,41721,565986,859330,902572,197322,509387,365122,967188,411119,422903,41376,930349,386428,548028,36175,1020531,417885,425134,978045,791796,151392,910905,855958,382245,83876,48107,415680,348979,892185,528657,364101,28175,504113,899804,511034,686871,894388,262022,74121,151200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]