SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170923 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170923 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524810,48230,634985,939726,35925,444807,513043,720824,377165,845346,170715,227482,211116,1023428,826644,499711,136593,527359,382331,372319,590911,802093,943170,260773,544754,897531,31165,931781,877880,940436,638615,171274,845484,273952,730321,126756,105090,908500,139170,371423,226217,944950,369262,942666,985187,868300,581879,427142,55895,597800,61141,253189,932266,568824,325927,123971,128840,687220,949145,186155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000957s ]