SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411026 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411026 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804592,672425,329513,652778,566398,188779,672615,764444,253723,382452,634951,974524,1033878,135768,214402,78907,179890,500171,84701,798575,83667,749053,171239,642459,994193,107307,329990,320408,19022,848269,676483,1028680,171690,781089,98407,698109,480679,1032184,723017,909944,419942,1007439,215413,717747,601773,1022494,555172,508611,707713,736192,589998,382010,242309,466729,596958,62518,339477,537670,909814,1002711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000947s ]