SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562404 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562404 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483625,1009629,110034,783839,326715,7345,316785,973141,629171,394100,872372,200130,967513,644792,215800,576341,971057,61604,781841,56472,914199,975607,798524,427032,585470,95005,63860,489098,38023,214741,844033,7306,780775,805277,86434,287273,373574,758804,779991,217581,67301,1020739,466126,189584,671723,325538,206534,884746,312615,710719,645834,802755,443971,558085,755700,215405,465046,491676,889753,729722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]