SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591401 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591401 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266771,313088,892089,970003,236775,827011,523641,551687,819561,920266,138248,472631,608964,131922,728926,851471,678640,116449,615104,357524,740219,393916,681184,413583,1014732,88062,782614,824704,535755,306686,825775,277014,574459,191339,141959,107536,302683,345087,355365,445554,508115,132697,218059,122406,636564,753645,56019,434505,613166,568880,163305,859089,551785,999062,323030,987480,435971,460942,298052,709112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]