SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106300 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106300 [ RunTime:0.003429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53561,161185,98167,60017,611114,882329,880191,12015,429452,934770,231900,294250,206610,62497,914938,268476,160611,55970,873714,79453,763567,423245,406627,601425,221620,148990,330159,232389,361187,457230,190014,428283,546511,857487,29484,125145,316436,815741,262937,801943,378597,669029,111856,854117,756924,221839,313453,737736,621566,786525,196577,119382,176911,277876,108495,330326,227331,872241,128201,796496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000799s ]