SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512383 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512383 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001441,53359,260308,571118,156886,176992,975169,289246,851410,966662,256837,113910,699319,341895,789276,864493,4191,869086,974059,914468,460548,86341,196633,1025774,887007,286487,254191,624147,293543,257970,137344,1048379,997098,194252,366030,1026778,524518,349630,945216,937479,128475,936239,734830,529598,892454,1010564,755576,1023269,898903,786809,245998,182857,248378,379913,67589,873531,968817,253810,518093,69001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]