SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338541 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338541 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20464,156874,284327,316272,955151,6423,502007,471062,717312,483894,176693,50096,262722,7763,779376,495946,299875,990573,6398,476584,11992,425586,947134,608465,124866,876644,995142,779040,757898,346518,409021,498111,878797,628249,494643,308628,955477,142815,772123,760790,49367,242723,594689,390242,121041,1038725,566840,831778,245300,1002461,830630,989112,411434,141906,787757,326202,100533,925684,394233,663417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]