SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429611 LIMIT 1 [ RunTime:0.001545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429611 [ RunTime:0.005145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424341,395792,881823,4523,396005,37173,455215,854042,433399,661788,979695,589521,628702,651961,184592,790469,724113,26444,353499,967435,333314,858721,107733,123357,626584,281810,492333,298013,128892,249555,170161,554746,803043,822195,190420,769003,934269,594821,801902,138596,952866,832131,883746,408594,139327,214102,501657,261339,880300,1042614,381631,111353,338106,787654,974204,148132,312739,116337,104759,100629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]