SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022520 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022520 [ RunTime:0.003431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147785,446131,942734,841015,457136,710381,39378,944124,801373,132587,451171,1003114,505685,66202,557819,306877,231704,243535,344027,984358,589111,711093,652120,626090,225384,538526,1045182,456893,542072,72130,217136,949264,773268,588134,676351,959443,179318,414518,588148,537722,611563,410769,949795,418938,209824,980864,329165,788811,534594,899184,647693,586878,89368,735289,358436,146529,693558,516797,340250,1019157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]