SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019905 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019905 [ RunTime:0.003534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96556,415024,946154,170763,888252,917869,946389,1024951,808442,576528,83439,930249,835821,1042768,255159,1032371,652181,827962,841002,962126,909301,646127,430991,830795,767439,796651,183541,1047441,996972,357124,631816,880194,228167,738286,298223,363729,792112,1026909,241751,322192,984314,589676,545893,317992,778440,810338,308388,1017826,1001224,85389,793369,1033095,72108,578901,406688,1015308,583941,880905,281651,406884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]