SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002548 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002548 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378993,128659,168255,789348,494300,55324,762734,791750,380,811642,299663,812598,775004,916027,973914,816556,208475,431328,246739,13030,754420,346822,797547,89884,194550,703075,119853,868995,376033,290532,314760,778923,581630,414172,113134,668145,687580,260670,960557,780018,975180,453551,527643,841510,1048611,143317,381625,920962,395567,234773,298552,53964,708754,821993,484916,666804,582453,323173,987714,547889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]