SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038514 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038514 [ RunTime:0.003417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959938,637157,799599,181601,77712,914140,151628,284657,954942,119471,453051,780026,559670,97515,46989,776718,1028644,761046,22272,81175,438640,1007022,302269,1015629,917920,558293,549578,216269,477752,251139,382611,89672,557965,721386,210414,972137,146971,465622,541649,79981,464137,1044203,84800,637284,809697,168513,448751,950087,798515,903541,969021,680454,620923,924239,378267,721768,693950,974102,613091,918161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]