SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529510 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529510 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701164,515798,778586,841860,330684,12608,46672,116682,640720,42623,530371,259340,707025,332994,21727,356893,714380,135150,132935,345049,673874,251011,232688,873099,663682,834516,198293,405191,735992,528280,870349,213591,294813,626057,64106,215959,654427,138379,446456,953192,644195,665029,976763,599449,82199,949640,678413,227393,521584,913775,581831,861228,19571,472270,584332,867125,330326,196842,687022,901914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]