SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421851 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421851 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876570,85961,719735,411820,97902,548723,565484,765084,1017201,303378,719175,615666,526076,582344,818982,177560,55108,684542,1030223,107702,935220,574183,559893,895009,417142,655032,832028,81801,908018,249768,791699,284631,38220,400365,707587,852366,518328,455017,690139,327454,121797,160533,789816,37495,380469,537991,29502,51302,264082,711005,50735,106321,102101,626347,902690,832122,715910,339161,948260,614313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]