SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001846s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448504 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448504 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344768,863800,196117,736715,17050,463802,637890,780932,410311,333815,923655,252812,823657,408398,1036029,295984,508195,47908,323749,17407,580718,734496,247003,1009209,920438,749519,635085,721732,659358,655703,35374,587171,526018,504467,67703,912463,584508,1025172,747860,287160,413216,120230,614908,101772,526293,976418,701197,788097,750955,4043,763030,638117,136400,857405,368898,181745,103687,10712,856849,1022013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]