SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175009 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175009 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948362,385200,865628,705708,1007224,402218,296302,345070,435520,715086,523799,160404,164349,40109,699258,383813,502087,18398,810308,456367,567085,101530,194156,291790,775970,345968,34011,252746,109258,522040,422892,522265,483661,924119,475483,995863,342819,39909,308958,779237,589231,481481,656207,798882,1028159,167381,269147,42955,513892,267911,657415,867991,860962,968483,795242,532250,1011770,578548,451930,470070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]