SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507712 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507712 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360182,764142,568281,598905,824373,842720,1006920,325401,200257,193889,198588,1023420,893029,563714,349018,827187,312978,732728,568778,552575,586302,904213,322051,120535,220098,126536,101404,253159,48172,618100,527244,330459,861580,274716,519640,3844,332093,268956,329478,617301,867237,486069,164105,710554,19705,302691,491603,57359,784703,760374,290429,233,663078,429135,140894,918891,251858,585524,706964,710635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]