SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335036 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335036 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047616,332159,332602,184586,126739,724743,903191,11494,915131,623298,1032895,544103,883903,105080,159791,449698,480031,352949,895711,509579,634668,1028100,683722,272902,78597,313686,717900,601958,163687,820924,330701,11620,344008,13839,284697,740252,561537,899878,600839,305783,454456,800744,447205,188377,731436,110788,428215,293527,335168,764108,98183,332280,106594,996805,156389,697117,745261,987802,910063,396589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]