SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597956 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597956 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580361,855692,408015,60677,848084,455289,664314,843116,776885,305862,91110,774493,167014,728472,789487,33565,214376,423582,847400,454537,255546,263320,7086,990913,237099,385036,488554,734318,51664,195288,855936,865206,981459,147850,238602,409243,852391,639397,641611,381603,561924,1017934,326372,35904,134942,367504,427149,700346,794136,219498,718060,164308,195303,882714,149177,503090,223611,413134,188487,97584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]