SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178203 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178203 [ RunTime:0.005909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564147,138386,390015,161276,342226,709815,165750,815301,103068,854204,921073,665741,445680,630746,410805,458609,575353,155945,948560,52982,913080,161828,177688,581926,202537,903335,715725,355492,128109,740238,43441,743198,144450,1016025,239740,184888,36280,372332,898428,902133,528473,107500,632146,116465,194709,762303,932853,297429,741783,1018862,871413,517389,876348,6160,617120,443660,840888,138075,806761,480531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]