SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002881s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684283 LIMIT 1 [ RunTime:0.000608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684283 [ RunTime:0.003438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300017,945084,551913,1034187,620341,720216,874681,905921,447136,884358,272957,572270,174848,815796,35213,850353,348767,538838,232714,437936,511026,91708,636768,537220,71309,900155,963825,214976,590265,9713,217837,110268,818819,267531,449814,694914,928046,857029,560382,794102,932430,685128,972640,362639,606096,1006541,658694,998012,733378,427641,703341,508458,247284,628314,815503,390711,235136,167688,95021,98320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]