SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023685 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023685 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717734,43209,922833,359163,395618,365645,111599,211760,169524,1047356,763430,330752,506621,340879,629961,839951,891019,390511,626208,415344,68136,161974,509039,799622,47090,401665,467069,592097,815756,779505,217674,826046,708726,909156,711316,541718,572823,651710,30824,704352,290776,999779,835540,388336,279271,886556,837432,164881,1004085,469393,1039220,792589,732250,748831,28858,600445,786791,597144,310848,871087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]