SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533191 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533191 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524681,74300,470647,491843,728115,874862,339879,365084,61777,505415,770382,332533,378296,287090,1014971,27497,412607,16984,356228,570157,812244,95383,264504,994850,987262,277072,239798,327768,968422,781980,994898,267810,375854,672724,771026,695738,222453,903285,1020797,1003407,405697,879456,129790,12178,309198,664261,27264,357048,869647,212309,345019,457136,560405,980103,152891,546225,268341,805145,115790,71958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002456s ]