SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433871 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433871 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446540,503772,217052,202767,620803,902223,895840,916960,1046988,287364,126991,500314,507610,275369,639654,946659,538120,716926,715050,245466,1042100,298369,190358,749021,640401,1043560,307870,227804,209676,384954,715304,183015,600580,400689,433807,889788,885972,9254,49599,97138,444624,641837,723006,126425,446202,1011506,368070,780157,874222,890080,754733,202176,889262,39891,273345,561429,710340,891603,504853,14870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]