SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406176 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406176 [ RunTime:0.003979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479694,557380,989317,102715,371784,840322,955004,1040228,916348,858315,750049,663618,21500,812014,501982,777991,987064,1012851,313118,870549,635883,418698,674010,416522,611464,367812,237769,683331,583661,1045275,887108,361146,165373,377975,267421,858606,746664,304265,810929,557514,207621,682461,327790,944465,902324,989328,554920,930665,372944,591915,684870,68827,894601,459071,977347,1040589,937769,468002,730167,322510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]