SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102694 LIMIT 1 [ RunTime:0.002125s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102694 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411713,1036006,962310,372897,164652,333373,52777,492041,455458,626855,387454,730654,577506,1025157,536988,670516,504624,737538,262097,626906,739961,688599,320161,383529,760622,611993,102786,926613,853346,897435,610452,802328,769562,877806,954562,679271,971965,688568,954863,508155,127046,357807,219239,366985,64507,265109,817789,852041,261998,72720,404844,446279,815781,589125,135504,605386,141068,475542,324559,123553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]