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` = 456074 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456074 [ RunTime:0.003991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81002,15715,80075,464733,856024,255367,674271,70723,455035,35895,372240,365463,37959,315079,957970,1030185,160615,671423,533547,490932,345540,456604,1022699,396211,386887,198344,709622,126822,911336,1683,560532,423907,706580,251461,976073,153947,127003,334620,563728,968215,11658,1008225,629369,194878,641401,532853,701257,317656,905698,926799,62130,838477,528548,213296,677977,232457,901532,920563,165979,813874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]