SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201310 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201310 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52162,79169,556812,912375,874631,113817,252743,306903,295849,243408,673864,430360,230077,270403,246913,241222,552289,628550,905901,976531,574973,872645,500913,293979,1033105,601405,221722,889997,807218,216524,754860,271622,855571,145838,450348,773332,599479,12976,452279,823237,712185,101819,330001,22845,115449,293642,482220,40378,851583,920051,527912,985218,694801,248860,566797,333912,726273,882413,270079,963078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]