SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504655 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504655 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215940,219541,748173,536895,77252,526661,504963,673794,290809,598583,66907,899600,992514,162966,945242,930949,999896,1011841,490782,481264,816281,392261,85801,552452,25105,556563,963880,540371,627472,1006370,762739,438082,512586,512244,805338,417873,57586,335419,473167,794384,69779,145163,895830,937084,423750,958505,489059,62344,363652,1026891,748337,501631,475713,594757,900510,421704,754119,602287,194398,232985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001852s ]