SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518813 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518813 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120504,463228,771613,736877,849232,262039,938067,413550,209430,859838,109320,244276,506521,680400,458967,751698,742242,1022899,84851,514941,726440,921912,711968,903346,936355,865155,198578,297528,378332,682209,89706,215870,60882,171543,57247,106098,45665,588249,688951,754427,381197,117566,110123,169819,634641,504707,553175,484834,1037278,257575,898913,47163,638583,628419,771568,903396,728826,170107,327214,764342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]