SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428833 LIMIT 1 [ RunTime:0.005009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428833 [ RunTime:0.005115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791720,226747,118088,1046053,387889,79140,761921,994512,565785,361834,742884,162773,786642,364020,619674,306500,1005900,751687,619852,450285,172123,735215,647258,178311,237147,739274,397224,834160,838812,118085,355859,819000,455342,241402,482010,78804,877595,788791,798141,545398,1041510,760561,508869,803718,966319,707485,891313,1037098,148384,597600,11131,169585,690600,671503,439892,543598,408833,462633,862279,745313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]