SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494939 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494939 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146615,335227,991464,148922,537658,164612,116636,395752,299636,399080,993065,672180,207382,158172,363611,426957,993642,1023284,421460,142827,559013,606305,55263,957791,783604,151964,688805,769836,388423,294280,1024240,749119,799160,812417,728470,363070,188900,123531,31179,579182,311795,411699,578333,1016596,935467,676699,165998,481441,585919,565306,11293,1011177,108196,764555,934855,704054,798566,588135,977512,316596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]