SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588576 LIMIT 1 [ RunTime:0.001325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588576 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550921,362358,315978,703852,958516,164175,612116,458936,320787,623968,919643,824313,665443,249122,131183,773743,490533,189600,480169,453317,680046,183429,319808,727601,938234,915365,271006,1011787,258995,102473,184966,573813,1010467,125780,906528,443079,1012562,1030565,805964,714017,360214,519525,103938,446504,336498,973569,881154,277875,902016,895522,597582,249222,826629,768856,568777,593011,715120,461571,726592,926369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]