SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401194 LIMIT 1 [ RunTime:0.000862s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401194 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728177,549702,967211,281857,670824,15023,757243,953186,659928,531546,459567,178356,708084,398935,468521,986446,74364,679923,17897,626093,931914,385470,371652,303986,181535,84746,927395,289220,675557,1029003,992268,882430,995120,475825,72935,704517,347873,67717,150648,402388,869273,869480,576175,820549,133592,526969,159899,854991,122104,903936,264721,272748,196210,974895,625236,858319,30010,980243,676123,949061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]