SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540415 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540415 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209412,241401,232405,894457,425280,576675,648658,841330,643274,354581,397052,944830,933885,273175,820125,497396,158999,116264,895004,439077,66188,49010,684657,530451,6918,125219,499009,370019,101591,441656,14051,663993,81071,299051,427846,303924,26099,728955,501331,981843,149834,202345,342442,9873,1013822,343531,174179,991350,339825,960523,389134,658178,649042,853743,207417,277322,220781,737265,969800,883685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]