SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009791 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009791 [ RunTime:0.005532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346283,250093,101875,561329,902446,759122,98643,220021,434438,708974,404667,325294,138716,157082,550854,93904,896264,750982,420626,197382,387504,26897,260315,237106,884819,230941,81633,951990,214732,814047,1006963,446539,363378,805477,620606,412088,45115,718005,883830,196477,1030559,726882,868583,545370,254255,864428,94814,262660,784393,478655,932638,532994,124628,441396,88378,962780,835791,910670,220834,438070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]