SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520032 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520032 [ RunTime:0.005312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8431,1045526,492372,387354,946059,522565,729607,993651,471463,637448,366106,855573,932208,306748,30563,139509,557519,1018599,240775,771037,258529,91001,336963,33462,734250,985153,934822,593849,90290,1029979,426351,397326,864414,644516,512046,587950,20361,465824,643626,350028,327064,730741,975159,469595,873548,526669,446736,375429,5851,205887,960645,914044,108360,603096,175388,990661,47969,754478,757428,23143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]