SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003994s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416771 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416771 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352533,587154,610265,746937,309348,383309,296112,1028350,1006958,1045096,823586,15650,336453,1039221,815215,54612,976616,425061,287652,251860,511152,566447,257276,622614,1036050,668139,425011,756799,192785,559271,194342,898912,898505,566064,177986,1015141,29579,266636,587152,153334,178650,501530,778325,772371,883963,953388,727796,278636,38371,804173,652440,646167,309876,585946,17848,993852,703275,311221,635138,973772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]