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` = 1019951 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019951 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523570,98996,479104,446331,567554,649594,346188,404767,252250,536928,793466,111520,247333,636601,490831,505960,929894,147615,230558,675203,126074,544307,284259,760822,808969,792513,886123,697405,202245,1026389,518113,980070,697128,506198,18253,773902,708038,253183,976743,12516,480549,104763,723383,687230,279139,815168,1010623,347884,367089,126624,783516,734723,1010408,327905,250455,358378,98577,480856,122096,997490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]