SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401575 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401575 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276274,1034042,399044,37250,253019,400121,826285,309869,921575,478284,323057,572909,916891,234892,82213,28577,4539,88876,332982,336828,779778,931307,346478,461445,795839,555326,669233,634287,423711,484797,430717,990344,1033024,118051,429001,943338,293267,281088,560348,809454,77547,51758,1023140,970,939087,613543,302628,604836,683098,968773,644530,618070,756891,904978,571414,664209,4986,728453,464355,995586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]