SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40172 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40172 [ RunTime:0.003131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151935,112326,722841,705440,604795,977783,843074,501368,209150,60596,1020629,451303,133102,674900,1044836,265416,369810,931778,113017,356755,403846,756141,981145,243771,542759,504940,1007639,383659,533583,620224,874616,564488,392893,922634,100482,868185,684629,215006,858602,798122,354435,441530,620494,285200,488515,352210,194217,299595,665914,488235,135743,330743,354667,565478,43557,970363,518951,960148,840860,686786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]