SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576222 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576222 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180341,547109,468072,935894,134574,825886,58300,159624,690556,802051,461712,833085,972810,1015104,48825,948634,26225,489944,547050,597460,563329,250048,449169,600918,903920,246907,48246,995480,415906,457103,962906,354173,231569,556407,994781,868630,353555,802236,680381,389455,550366,411358,8746,677566,708643,673386,802364,140184,432732,566950,25214,160231,647233,615031,170972,868625,284636,755333,366567,1046433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]