SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020036 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020036 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910935,663448,876544,957785,500256,242780,934712,11608,16824,294187,1047912,449703,595962,23286,338235,995376,565391,13522,277928,483778,523683,267821,177190,721910,1038632,641759,487868,347865,610443,511902,898996,65874,959379,409992,46610,679618,378298,106250,727154,84569,519427,731314,651001,599199,522544,618637,1038318,259179,750659,223769,283405,443690,881765,270552,80816,272655,59354,240581,821278,1035788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001903s ]