SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561063 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561063 [ RunTime:0.003530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17552,1011398,417258,456994,408599,152516,415210,861636,672921,644391,199289,814954,18046,33534,310224,541064,742406,62527,468796,759400,127356,710816,688560,409463,134091,814399,208783,752267,877894,395844,445201,87413,113115,612139,207059,250675,818291,258394,469555,606121,561617,827373,175897,224928,407291,382114,98474,729995,46945,473965,315259,8541,504598,865538,655340,744069,832191,399264,879926,496787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]