SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801003 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801003 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512607,82211,776267,451010,566586,949548,682214,954817,719104,212873,247864,952972,269552,155527,502625,440674,397133,356988,407325,19263,271273,192579,239610,686380,493954,788936,363275,8033,129978,565645,895896,197054,156450,834276,817242,955595,773130,828180,7398,191859,350323,144321,756210,459098,520262,816840,782359,1024347,414550,536909,1008829,883167,503581,178889,515900,951572,162572,947506,450052,275433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]