SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510752 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510752 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636872,917830,33474,166134,234848,608414,555098,98665,108386,33779,266560,135832,42249,1017074,482981,942638,300261,253123,785353,489080,422238,49672,150248,583791,310552,735442,598902,600177,78353,363008,141170,331856,637853,988593,375086,173624,309985,241211,523075,507383,978433,70225,435691,109011,306667,648974,358966,296579,568491,1031019,63804,592547,231439,908184,581326,88797,372450,793377,644476,964420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]