SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326540 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326540 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649032,443336,961245,523211,426673,804211,967236,776724,654401,840977,121024,1003314,997374,960223,402884,357929,695391,337160,412952,789223,46909,789836,864209,429519,42938,894628,580841,228420,403947,358813,785804,89672,653471,246041,559335,736981,197269,284724,424471,845587,65441,546935,605017,110849,220181,1031145,790288,490350,541896,602325,819006,791760,684825,109103,375970,685123,280058,108849,602991,280243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]