SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414324 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414324 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120022,195293,331815,97892,488252,296892,993124,583743,32134,304516,11519,384821,474110,245313,958788,842836,545363,573061,377295,839880,505612,213417,586184,1003041,85158,326137,707944,605254,195299,1010912,785056,219046,206335,868323,275184,232224,177383,874774,363208,549734,751657,947342,380719,276859,97257,181404,828134,673268,11929,655225,897109,428609,63231,291117,667431,1039212,564903,32000,867820,10222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]