SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018371 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018371 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87067,422772,876973,399328,288828,504716,65427,105177,974081,381867,565241,669340,182353,465846,917529,296784,753317,42629,921457,470495,965191,962187,716761,858879,993174,140931,24602,624316,584843,304921,734258,674329,239745,562461,325631,413838,335938,99643,63122,240859,831055,711019,988501,1010510,83734,723663,543928,430704,316774,1037287,388716,415814,1030645,706658,202793,115127,515867,266893,660376,640090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]