SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387160 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387160 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509036,738329,960965,834729,98794,843409,516216,229134,389719,758262,309659,874286,401018,403713,520416,665334,237291,154445,177460,293082,164238,596212,736124,236085,326814,972104,620438,1015331,207320,593389,133783,719771,883152,636521,428704,500612,655500,15378,603658,479237,231709,998561,762365,483108,107221,703967,676544,800941,437521,614366,992595,822370,280444,403438,693903,489506,14465,51654,360761,560241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]