SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011646 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011646 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98902,658522,767849,871741,614895,68805,117584,25204,795487,853002,816433,4206,961210,270816,928261,593650,774694,64000,1008162,109548,945166,829739,120154,369988,422967,500859,458633,376040,98135,899095,750030,1027379,627708,635726,888612,994229,642435,63325,340770,694587,316826,172344,885124,471221,416192,158902,672588,483863,352252,509519,146555,1028438,690613,1030000,393511,406570,221565,269756,289709,975683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]