SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424180 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424180 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935034,520416,41572,497916,95173,232268,33842,375371,375514,741447,871663,50020,536885,296112,200114,15907,495701,459320,1037029,797350,612301,691655,596371,172715,301281,904604,208242,309643,97097,743599,437493,158903,268468,306443,435079,54982,666672,45395,73274,552286,171016,988044,741572,596531,892773,358290,283660,174958,461474,507635,1023376,812640,337379,142598,391650,398632,72273,168831,981466,876229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]