SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437857 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437857 [ RunTime:0.005352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858609,617048,543029,673387,848437,555462,954330,804999,87382,849958,871809,628204,412917,1000300,657659,345703,728549,971707,14370,9980,125216,26235,671889,520607,471147,157643,735981,520653,967200,227280,606903,117508,154945,623523,469535,1000836,925424,130428,992686,132042,199906,421341,1039066,306023,929388,48810,567047,374341,680290,820888,296680,11515,605760,192662,873929,926330,281643,666543,379002,897366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002668s ]