SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340248 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340248 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533707,1000530,188559,932321,186649,228088,397982,145542,141425,967112,519942,745668,129986,285488,772119,7775,611500,636780,50314,633954,383430,30736,678751,670823,976776,57930,182155,767820,164213,1048220,1009464,127040,592477,364503,764822,467323,747458,526873,892161,752462,715110,442744,656643,734235,663883,673966,908895,613641,491843,930319,95409,593113,360790,1017447,566902,477144,283008,270009,301228,686504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]