SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471382 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471382 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914725,330554,471436,704252,136821,748189,803205,733556,26474,1025745,525302,174687,410351,592833,271576,322183,568200,495050,463584,144963,586093,132204,327263,368424,404195,415255,1037685,690856,999562,128260,557169,33913,316756,574481,318370,628249,810246,778731,763073,361029,90621,99387,345116,862178,298190,128429,450223,119588,857535,849339,1036142,513596,357279,41377,147773,95738,678425,168345,20260,6333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]