SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027597 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027597 [ RunTime:0.002272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606920,726381,848822,671023,416343,151239,994745,509776,290731,900233,720598,853685,862215,919029,238611,169810,139565,362376,971629,628690,995360,888060,135154,691905,383482,499437,236261,488663,512294,858545,729035,56258,359761,774744,546994,574594,553111,119643,328931,878215,310390,21592,936387,465985,131798,1000644,523627,235969,697378,883661,922484,1023531,646750,734510,767317,651852,686257,41235,1043047,291195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001352s ]