SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044031 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044031 [ RunTime:0.004636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107897,798391,982106,635511,760085,502352,566483,730873,578816,1015626,158712,434493,829465,705338,312486,290646,887977,300856,439013,599435,271732,239605,952767,70735,630854,507299,633896,235589,409153,236631,400389,575912,407419,887463,212501,38753,929252,549445,107840,194606,403098,713425,646261,227039,317423,1045253,777079,924570,738096,383000,757411,213618,413427,109035,331180,306871,607475,395666,581239,196242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]