SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003994s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68683 LIMIT 1 [ RunTime:0.001052s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68683 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528673,452797,465620,715499,971686,92287,310109,842621,877427,212165,352949,336697,1010444,898233,772583,153076,676480,648956,802900,698165,740894,1002633,397888,568542,382067,600526,230113,104051,538626,568919,38132,538186,413465,860929,871912,661891,829674,221040,574226,247272,378320,341913,62596,429365,443395,392511,261603,828240,496092,536892,56636,852905,423640,41965,415331,754109,243646,239388,464973,716059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]