SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520183 LIMIT 1 [ RunTime:0.000781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520183 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654608,236892,594058,197895,359004,494094,282801,113973,683407,151553,790039,737727,309692,466186,252891,1013313,384621,354680,1037284,316885,504488,989763,23751,857233,151274,964076,169571,558425,335340,628397,829635,841109,440233,378048,555956,812983,442631,7540,373327,763739,532370,31083,1347,1011622,1022015,92350,919661,353269,678701,556991,649430,232040,658280,772558,974192,699877,146443,502823,725222,412669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]