SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441753 LIMIT 1 [ RunTime:0.003915s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441753 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257181,140054,882755,381155,265820,41476,334955,894645,678491,186087,937267,620577,475342,606966,351621,98177,1019731,625547,790466,713119,1037567,531613,407506,934368,249152,834783,409099,1036310,148343,920693,55102,750469,481288,247879,456886,965806,960942,316992,615937,257099,736564,96088,936054,843253,803988,142135,407602,574336,206675,332602,92440,827930,816851,364118,676332,952355,1031004,319423,381910,424645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003294s ]