SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505429 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505429 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417280,495955,767537,190646,421474,75997,710389,804695,381007,379236,765853,466768,500271,408757,670209,657848,78342,17552,13995,323711,769208,233301,419052,582768,160172,696496,787745,418438,477888,1010576,635453,559873,545377,815855,840097,640940,585908,896506,490981,499818,1022976,774116,729919,88567,620289,511129,996576,772120,360262,350025,305853,966877,436968,1009098,365326,542833,721646,41161,314531,627532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]